<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ page import="unit.EscapeUnescape"%>
<%@ page import="websql.DBcon"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
	request.setCharacterEncoding("UTF-8");
	String cid = request.getParameter("cid");
	String qname = request.getParameter("qname");
	String qsql = request.getParameter("qsql");
	String qid = request.getParameter("qid");
	String sql = "";
	String stp = request.getParameter("st");
	if (stp.equals("新增")) {
		sql = "insert into query (cid,qname,qsql) values ('"
				+ EscapeUnescape.escape(cid) + "','"
				+ EscapeUnescape.escape(qname) + "','"
				+ EscapeUnescape.escape(qsql) + "')";
	}
	if (stp.equals("修改")) {
		sql = "update query set cid='"
				+ EscapeUnescape.escape(cid) + "', qname='"
				+ EscapeUnescape.escape(qname) + "', qsql='"
				+ EscapeUnescape.escape(qsql) + "' where qid='" + qid
				+ "'";
	}
	if (stp.equals("删除")) {
		sql = "delete from query where qid='" + qid + "'";
	}
	try {
		DBcon.exsql(sql);
	} catch (Exception e) {out.println("<xmp>发生异常,如果是删除数据库查询，请确保查询下的所有条件都已删除");
	out.println("sql语句：\n"+sql+"\n");
	out.println("异常信息:\n"+e+"\n");
	out.println("堆栈信息:\n"+e.getStackTrace()+"\n</xmp>");
	}
	;
%>

</body>
</html>